
const router = require('koa-router')();
const util = require("../common/utils")
const { sequelize } = require('../common/dbs')
// navinfo
const navModel = require("../models/nav_list")
const navinfo = navModel(sequelize);

const navShareModel = require("../models/nav_share")
const navshare = navShareModel(sequelize);

const navTypeModel = require("../models/nav_type")
const navTypeinfo = navTypeModel(sequelize);

// 根据类型返回列表
router.get('/list', async (ctx) => {
    try {
        let reqQuery = ctx.request.query; 

        navinfo.belongsToMany(navTypeinfo, { through:navinfo,foreignKey: 'typeid', otherKey: 'id' });
        // navinfo.hasMany(navshare, { foreignKey: 'nav_id', targetKey: 'id' });
        // 查关注表
        let navData1 = await navshare.findAll(
            {
                attributes: {
                    exclude: ['deletedAt', 'updatedAt'],
                },
                include: [
                    {
                        model: navinfo,
                    }
                ],
            });

          ctx.body = util.resultSuccess({ data: navData1 });
    } catch (err) {
        console.log(err);
        ctx.body = util.resultError({ data: null });
    }
})

function getuuid() {
    let s = [];
    let hexDigits = "0123456789abcdef";
    for (var i = 0; i < 36; i++) {
        s[i] = hexDigits.substr(Math.floor(Math.random() * 0x10), 1);
    }
    s[14] = "4"; // bits 12-15 of the time_hi_and_version field to 0010
    s[19] = hexDigits.substr((s[19] & 0x3) | 0x8, 1); // bits 6-7 of the clock_seq_hi_and_reserved to 01
    var uuid = s.join("");
    return uuid;
}

module.exports = router.routes();